UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CD8R3v8Umsx28zk6AA0eJ5en5x7+Pc3PRIpC0U0gXVo='
WHERE
key_id = 'd2ebcd462c027f50614a4ec43077715aa71cb2febd557f8b4619492fd1b024a1'
AND (
token = 'CD8R3v8Umsx28zk6AA0eJ5en5x7+Pc3PRIpC0U0gXVo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)