UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ilJk7SPOirNnjwSbFRIvZc8v+jXUAOO4IATx5XVPVGw='
WHERE
key_id = 'f567b232cb9bd07020f0b674240da71f56f1992ba79356d4452d5ff752728c71'
AND (
token = 'ilJk7SPOirNnjwSbFRIvZc8v+jXUAOO4IATx5XVPVGw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)