UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GjdZI5j8WK8cXsahA179++RlF4ILOx4Sbjs2W179rks='
WHERE
key_id = '86fa19818051655d9235c8e1309e309db23ffd47cbad2a4a0b8419f8705b9fb1'
AND (
token = 'GjdZI5j8WK8cXsahA179++RlF4ILOx4Sbjs2W179rks='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)