UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Lk3/cCw6O9vJFjYwORGOh7hH6f0MWxuKtn6aYWd+65E='
WHERE
key_id = '3029f6bb86cae830c450e379957f112e8dd072ea656cf3bcf3ae9ac852f6f0ee'
AND (
token = 'Lk3/cCw6O9vJFjYwORGOh7hH6f0MWxuKtn6aYWd+65E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)