UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XyV8zsa7ZlNn5Qso9rjbZ0SQR5jJyv2iKXMI/o9s6bA='
WHERE
key_id = 'd21c50276138c0837bac6432ed6199c9f78b82be71c05d4dd189ab8a4265e77a'
AND (
token = 'XyV8zsa7ZlNn5Qso9rjbZ0SQR5jJyv2iKXMI/o9s6bA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)