UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GdE8nbWaj5nCl0JxuAFikhkqjNMdVPHyl6+wdRogIow='
WHERE
key_id = 'f1b97c647994b6530578387026de4221b02f7dded84eaf036416f13af48c7cf5'
AND (
token = 'GdE8nbWaj5nCl0JxuAFikhkqjNMdVPHyl6+wdRogIow='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)