UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iCITGQ3gnmLM8YsGh6OjMd8PZYd2HCUuvWwQdYyJfMw='
WHERE
key_id = '5d807beada2b16c831c929ad95ab3af7fc0aad7bfa86115f9d490048096429a9'
AND (
token = 'iCITGQ3gnmLM8YsGh6OjMd8PZYd2HCUuvWwQdYyJfMw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)