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