UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5lg6CKARUglxlnblOuuHMZNtyYlrxvwwMyUYhgUf4iA='
WHERE
key_id = '4aca9245100aaa8053fc8697dce7fafe5de3e016826ec9727d3b2d47435358cf'
AND (
token = '5lg6CKARUglxlnblOuuHMZNtyYlrxvwwMyUYhgUf4iA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)