UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QC2R0KYPg0FQq9UNt9ZCwE6pKXPqkzLSE5bkcyX9tu4='
WHERE
key_id = '3b781244e0a9749eaf5d6e4d33c946d617335b26c2fc688fce716217b9f9f754'
AND (
token = 'QC2R0KYPg0FQq9UNt9ZCwE6pKXPqkzLSE5bkcyX9tu4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)