UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N8Q4VavJKLPrJsSmtk63Mv6dof3TC32kRJGI+CGWccw='
WHERE
key_id = 'b1a443069b34d27f5a912105ddaa7ea0ef2fc3b774e57046b26735909b1ab846'
AND (
token = 'N8Q4VavJKLPrJsSmtk63Mv6dof3TC32kRJGI+CGWccw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)