UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XgDIMccl0pjlrSd4T4/rGd1S+GzLYqsrZ1+jUHksoLc='
WHERE
key_id = 'a7d853d9b53af5c7e8dd26de38859ba503e085191cec88430548e3642e2dd8fe'
AND (
token = 'XgDIMccl0pjlrSd4T4/rGd1S+GzLYqsrZ1+jUHksoLc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)