UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BBPzmoayzg1WNndsA7o9zL/kmRph6ElQnaGgazd44gY='
WHERE
key_id = '3eafc94ef866b86869bcb09b3b11015a969d8aba49e23e989553bba0efd5da50'
AND (
token = 'BBPzmoayzg1WNndsA7o9zL/kmRph6ElQnaGgazd44gY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)