UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XIhucEfvyqBj7+n8Av6DK1E/+wGD0b12QfdbXNyH5+w='
WHERE
key_id = '694fc5180e64b5aa91f02343d8d5cbc11baadeab24b7b9ef5fad1929f4008786'
AND (
token = 'XIhucEfvyqBj7+n8Av6DK1E/+wGD0b12QfdbXNyH5+w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)