UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N8chr1h1qQH75/U9tuzjKuDKJEqp1ekyzIAHR5EevFM='
WHERE
key_id = '99ba1040a3fc320edca38e940d8ea6bb7f32b50266928bca11ea8514817ef547'
AND (
token = 'N8chr1h1qQH75/U9tuzjKuDKJEqp1ekyzIAHR5EevFM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)