UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dP4G+G+I8aE3/LTdKlHA1weMmHAocQugmd37zqlFTN8='
WHERE
key_id = '065181e59939cd6ae66cda91e3fb4fcf1a109952d29b0b84bddc5584f7188f23'
AND (
token = 'dP4G+G+I8aE3/LTdKlHA1weMmHAocQugmd37zqlFTN8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)