UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VHrOqGJMC4QDcC+c7d0K+u1qH9ZZtKeU2tQCSXZh3EY='
WHERE
key_id = '2a8cd567c6bb3dda94252a2cc1227520335fe9cdc3bc2f55a37bb6f2ce64954b'
AND (
token = 'VHrOqGJMC4QDcC+c7d0K+u1qH9ZZtKeU2tQCSXZh3EY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)