UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a5HmL51uNJhFG3UtK36mtRIiSOv8lxeSI3CcumjvwDg='
WHERE
key_id = '9c20b3c065955df01e6b5869ca820f07098ced440cb9158cfc58c4486b508b04'
AND (
token = 'a5HmL51uNJhFG3UtK36mtRIiSOv8lxeSI3CcumjvwDg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)