UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KsaF6gPqqED8yyEj73auj1VVScIHokqED+XrHVle3+U='
WHERE
key_id = 'c2fbb459d7a6472ed56528b13685b3477a045ef7ac08dc0e7eb83e24cf729202'
AND (
token = 'KsaF6gPqqED8yyEj73auj1VVScIHokqED+XrHVle3+U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)