UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ICEBCwyvYy+z7dqmJauXXF8kY5RhbKsQ3eU7w46emK4='
WHERE
key_id = '197a8948376f205526bc078edcde666dc871dc865bd897284294b48eb3c1c99a'
AND (
token = 'ICEBCwyvYy+z7dqmJauXXF8kY5RhbKsQ3eU7w46emK4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)