UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'i+CkGg9UWwcvF6YrYV/tE59QnTU0jt2l0arWzO2SrN4=' 
WHERE 
  key_id = 'db9c4f2df6fde375066d04167f99af23400b1b9d4f27835fa88a43e0033fa00e' 
  AND (
    token = 'i+CkGg9UWwcvF6YrYV/tE59QnTU0jt2l0arWzO2SrN4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00052