UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hdhYWtu3BT/0Un2o8PcBPCEsaBKf99CeWOJ30N2jIUg='
WHERE
key_id = '1064b1c104d52abe1d2dc8c8fe91987e89bae9fab7ab8578b984dda3259f4af6'
AND (
token = 'hdhYWtu3BT/0Un2o8PcBPCEsaBKf99CeWOJ30N2jIUg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)