UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'ZyWYv2zh77SJ8EZXf1ggXKyuUzCv/4W1C9xd5VNzxNw=' 
WHERE 
  key_id = 'c8c01c849998d8bf197a1c395d17d004fcbdc983dd67f23f4c291df3787195e0' 
  AND (
    token = 'ZyWYv2zh77SJ8EZXf1ggXKyuUzCv/4W1C9xd5VNzxNw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00035