UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cSvH+8aicg5gSlINF7IJo1SuV9JQBrAZ3tHyiYyM3hg='
WHERE
key_id = 'c291e9ae2712489e0ace8db097effbec8c33b450ac9bbb77c876a4c4bed9cc60'
AND (
token = 'cSvH+8aicg5gSlINF7IJo1SuV9JQBrAZ3tHyiYyM3hg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)