UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Zd+lthczuOeZiQMkCV9L7sZJOBiQjnKV94/+xG1+cjM='
WHERE
key_id = 'deae23b18698834434a1656d151583c9f8e643c69e39c69c783da5ed02b7eaf0'
AND (
token = 'Zd+lthczuOeZiQMkCV9L7sZJOBiQjnKV94/+xG1+cjM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)