UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PVk7YsudMLxIoVkMFY5YilJYgvFN4HeX5VaYmVLNxek='
WHERE
key_id = '1c87bb6e81f8c5ad7f747992a1dea235b9db9cc9d39ff0bb568d728f2d5d617e'
AND (
token = 'PVk7YsudMLxIoVkMFY5YilJYgvFN4HeX5VaYmVLNxek='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)