UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'kf0YG11nsiOZRw43hEE8+eRPV7ooVgQyic6tB+eAnqA=' 
WHERE 
  key_id = 'ff49d0adecc3afa31a4f98eaa01963982965bc6ca352db49bfb2b69d40339111' 
  AND (
    token = 'kf0YG11nsiOZRw43hEE8+eRPV7ooVgQyic6tB+eAnqA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00035