UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'S2BWSxeNxtWoujDgesTpeK0iI2kGqbrkp0ElmPKy9Z8='
WHERE
key_id = 'd0bf30f62ea439fec79616fec72e5546e66db3f11d1b435b764f443f0d08513a'
AND (
token = 'S2BWSxeNxtWoujDgesTpeK0iI2kGqbrkp0ElmPKy9Z8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)