UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '6HVfM7rf00/nlvc4L+nTo9EL/4LAdpspjQeS4/sOKZg=' 
WHERE 
  key_id = '052a7862a0d97305e02ebcdecf7865df7c4b33f62e0567e2e55f3823b1fe2eed' 
  AND (
    token = '6HVfM7rf00/nlvc4L+nTo9EL/4LAdpspjQeS4/sOKZg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00018