UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/0sZsKtEdsfQMrRlqmvlIpZ5MAgAUao/za0li16PupY='
WHERE
key_id = '3dc1fed6ad485fa98da7747ab6e0f509c5f68f142b133dd8dafaa7b7cfabd34a'
AND (
token = '/0sZsKtEdsfQMrRlqmvlIpZ5MAgAUao/za0li16PupY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)