UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sk+3qhYDJgfFFXAzpsjDU733wpxIdJY85TQL3a5/7Qg='
WHERE
key_id = 'cb19b3e220f7665c7253307357b3c0fac0256f0145e43639b280152bb8fbb078'
AND (
token = 'sk+3qhYDJgfFFXAzpsjDU733wpxIdJY85TQL3a5/7Qg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)